<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namespace 命名空间  该映射文件对应的映射器接口-->
<mapper namespace="com.ty.mapper.LoanSheetdetailsInquiryMapper">

    <insert id="bathSave">
       insert into erp_agent_inquiry_sheet_product (relation_sn,product_number,product_name,pieces,gross_weight,volume,support_number) values
        <foreach collection="agentInquiryProducts" item="p" separator=",">
            (#{sn},#{p.productNumber},#{p.productName},#{p.pieces},#{p.grossWeight},#{p.volume},#{p.supportNumber})
        </foreach>

    </insert>
</mapper>
